Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
PersonNamePartID (PK) | A system generated unique identifier for a part of a Person Name. | ID_NM_PRS | Identity | integer | |
PersonPartyID (AK)(FK) | A unique, system assigned identity for a Party. | ID_PRTY_PRS | Identity | integer | PersonName(PA_NM) |
EffectiveDate (AK)(FK) | The datea person's name is effective. | DT_EF | EffectiveDate | date | PersonName(PA_NM) |
PersonNameTypeCode (AK)(FK) | A code that describes a role that a name part plays in a person's name. For instance, names may comprise given names, family names, middle names, etc. | LU_NM_PRS | Code6 | char(6) | PersonNameType(PA_TYP_PRS_NM) |
RelativeOrderNumber (AK) | A positional number to indicate the relative order of a person's name part within a name type. For instance, if person has two last name parts, then the relative order number would set the order of those name parts within the set of last names. | AI_ORD_RLTV | Code2 | char(2) | |
PartName | The lowest level of granularity of a Person's name. | NM_PRS | Name | varchar(40) | |